Office Automation & Digital Literacy Track

Basic Computer Course
CIT Foundation Syllabus

An essential operational manual for computer baseline literacy, administrative documentation, dynamic data spreadsheet analytics, and official presentation systems. Tailored for absolute beginners and aspiring office administrators.

Prime Group of Services ยท IT Education Center ยท Mirpur AJK
01
Month 1: Operating Systems, Typing & Document Writing (MS Word)

Understanding underlying GUI operating systems, mastering blind touch-typing speeds, official office correspondence, and structural paragraph documentation layouts.

Month 1 โ€” Windows OS & Microsoft WordPage 1

Syllabus Layout โ€” Weeks 1 - 4

๐ŸŽฏ Month 1 Educational Core Target

Bacho ko Windows operating system ka workflow samjhana, daily touch-typing practice routine generate karwana, aur Microsoft Word mein administrative letters aur reports layout handle karna.

Week 1: Computer Concepts & Windows Operating Environment

Introduction to computing hardware systems: CPU, Input/Output peripherals, RAM vs Storage structures. Interfacing Microsoft Windows GUI layout. Creating nested directory folders, file systems management, task manager tracking, control panel settings.

Week 2: Blind Touch-Typing Mechanics & MS Word Intro

Mastering keyboard layouts alignment: Home Row, Top Row, Bottom Row indexing rules. Daily practice modules using typing tutors to build accurate WPM speed without looking. Introducing Microsoft Word: Interface setups, page setups, font formatting properties.

Week 3: Advanced Document Layouts & Official Tables

Paragraph structures mechanics: Alignment, Indentations, Line spacing controls. Implementing Bullet lists and nested outlines. Designing complex database Data Tables in MS Word: Merging cells, cell margins, background shading, borders styling styles.

Week 4: Professional Office Correspondence Automation

Page layouts blueprints setups: Margins sizes, Orientations, Columns splits. Inserting automated Footers, Headers, and Page numbers parameters. Mastering **Mail Merge utilities** to generate mass automated certificates/letters pipelines. Print preview checks.

02
Month 2: Data Spreadsheet Engineering (MS Excel)

Building relational cell matrices grids, executing mathematical functional formulas, filtering corporate ledgers records, and rendering visual data analytics charts.

Month 2 โ€” Spreadsheet Calculations & MS ExcelPage 2

Syllabus Layout โ€” Weeks 5 - 8

๐ŸŽฏ Month 2 Educational Core Target

Bacho ka dynamic math logic clear karwana spreadsheet calculations ke zariye, inventory accounts templates design karwana, aur logic statements apply karwana.

Week 5: Spreadsheet Grid Architectures & Cell Basics

Microsoft Excel structural environment layout. Understanding Workbook vs Worksheet models. Cell referencing rules: Rows columns coordinates, Absolute ($A$1) vs Relative address mechanics. Continuous data auto-fill grids. Basic cell borders layout mapping.

Week 6: Fundamental Formulas & Arithmetic Automation

Executing arithmetic operational algorithms: `SUM`, `AVERAGE`, `COUNT`, `MAX`, `MIN` formula blocks. Designing corporate office expense ledger sheets, salary slips templates calculation matrices, and automated student grading marksheets.

Week 7: Logical Statements & Data Management Filters

Deep dive into conditional logic operators: Utilizing the `IF` statement strings to parse evaluations metrics. Sorting relational data blocks, deploying dynamic Data Filtering grids. Conditional Formatting rules (Highlighting specific rows based on values).

Week 8: Visual Analytics Charts & Print Adjustments

Converting alphanumeric tabular numbers into graphical media layouts: Inserting Pie charts, Column tracking charts, and Line graphs. Configuring printing bounds for vast tables: Page Breaks adjustments, Scaling columns to fit single page boundaries.

03
Month 3: Presentations (PowerPoint), Internet Browsing & Freelance Basics

Designing interactive visual pitch decks, secure web surfing operations, official business email workflows, and foundational computer career guidance.

Month 3 โ€” PowerPoint, Internet Literacy & CareersPage 3

Syllabus Layout โ€” Weeks 9 - 12

๐ŸŽฏ Month 3 Educational Core Target

Bacho ko executive level multimedia slide decks banana seekhana, business communications par professional email setups guide karna, aur baseline computer jobs support clear karna.

Week 9: Presentation Blueprints & Layout Engineering

Microsoft PowerPoint workspace structures. Selecting master theme color templates. Slide layout architectures: Title slides, comparison panels, text content splits. Incorporating high-res imagery, shapes, smart icons grids. Maintaining layout spacing harmony.

Week 10: Animation Mechanics & Presentation Delivery

Applying professional motion graphics: **Slide Transitions** (Fade, Push morphs) vs individual **Object Animations** (Entrance, Emphasis tracks). Setting up timing cycles, looping tracks. Best practices for live speech delivery matching visual slides.

Week 11: Internet Protocols, Secure Surfing & Official Emails

Understanding search engines indexing operations (Google web searches). Cloud storage mechanics: Google Drive files uploads/sharing profiles permissions. Corporate Email setups: Composing professional emails, file attachments compression protocols, signatures code blocks.

Week 12: Career Roadmap & Comprehensive Final Practical

Introduction to basic data-entry job landscapes. Designing professional structural Resumes (CV) in MS Word. Final live capstone computer examination: Generating 1 business letter, 1 calculated inventory balance ledger sheet, and a 5-slide corporate pitch deck.

Prime Institute Basic Computer Performance MatrixPage 4

Course Progress Tracking Index Checklist

Aap bacho ke documentation skills, spreadsheet logic benchmarks, aur practical office applications assessments ke liye is standard tracking management dashboard layout matrix ko use karein:

Phase SegmentApplication ConcentrationMandatory Practical Evaluation MilestonesSyllabus Weightage Progress
Month 1 TermWindows OS & Microsoft Word DocumentationAchieving 30+ WPM blind typing baseline & creating multi-recipient Mail Merge letters.25% Certified Scope
Month 2 TermMicrosoft Excel Spreadsheet CalculationsBuilding independent dynamic salary tracking ledgers using automated nested IF formulas.60% Certified Scope
Month 3 TermMS PowerPoint, Web Browsing & Office UtilitiesDesigning 5-slide animated pitch deck & drafting professional cloud-attached emails.100% Course Pack Complete